﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Gestion des fiches d'intervention en cours sur Res@Core...</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table id="TABLEMEP" cellspacing="0" width="100%">
            <tr>
                <td align="center" bgcolor="#ffcc33" colspan="3" valign="middle">
                    <strong><span style="font-size: 14pt; color: #ffffff; font-family: Arial">Liste des
                        fiches d'intervention en cours d'utilisation sur votre noyau Res@Core®.</span></strong></td>
            </tr>
            <tr>
                <td align="center" colspan="3" style="height: 21px" valign="middle">
                    &nbsp;
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" CellPadding="4" DataKeyNames="resaid" DataSourceID="SqlDataSource1"
                        EmptyDataText="Il n'y a aucun enregistrement de données à afficher." Font-Size="Small"
                        ForeColor="#333333" GridLines="None">
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:CommandField ButtonType="Image" DeleteImageUrl="~/IMAGES/cut_16.gif" SelectImageUrl="~/IMAGES/arrow-forward_16.gif"
                                ShowDeleteButton="True" ShowSelectButton="True" />
                            <asp:BoundField DataField="resaid" HeaderText="resaid" ReadOnly="True" SortExpression="resaid" />
                            <asp:BoundField DataField="localid" HeaderText="localid" SortExpression="localid" />
                            <asp:BoundField DataField="samuref" HeaderText="samuref" SortExpression="samuref" />
                            <asp:BoundField DataField="createur_id" HeaderText="createur_id" SortExpression="createur_id" />
                            <asp:BoundField DataField="createur_team" HeaderText="createur_team" SortExpression="createur_team" />
                            <asp:BoundField DataField="date_C" HeaderText="date_C" SortExpression="date_C" />
                            <asp:BoundField DataField="modif_id" HeaderText="modif_id" SortExpression="modif_id" />
                            <asp:BoundField DataField="modif_team" HeaderText="modif_team" SortExpression="modif_team" />
                            <asp:BoundField DataField="date_M" HeaderText="date_M" SortExpression="date_M" />
                            <asp:BoundField DataField="date_CL" HeaderText="date_CL" SortExpression="date_CL" />
                            <asp:BoundField DataField="commune" HeaderText="commune" SortExpression="commune" />
                        </Columns>
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <EditRowStyle BackColor="#999999" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseInterventionConnectionString %>"
                        DeleteCommand="DELETE FROM [list_itv] WHERE [resaid] = @resaid" InsertCommand="INSERT INTO [list_itv] ([resaid], [localid], [samuref], [createur_id], [createur_team], [date_C], [modif_id], [modif_team], [date_M], [date_CL], [commune], [codep], [utmx], [utmy], [pays]) VALUES (@resaid, @localid, @samuref, @createur_id, @createur_team, @date_C, @modif_id, @modif_team, @date_M, @date_CL, @commune, @codep, @utmx, @utmy, @pays)"
                        ProviderName="<%$ ConnectionStrings:DatabaseInterventionConnectionString.ProviderName %>"
                        SelectCommand="SELECT [resaid], [localid], [samuref], [createur_id], [createur_team], [date_C], [modif_id], [modif_team], [date_M], [date_CL], [commune], [codep], [utmx], [utmy], [pays], [fixml] FROM [list_itv]"
                        UpdateCommand="UPDATE [list_itv] SET [localid] = @localid, [samuref] = @samuref, [createur_id] = @createur_id, [createur_team] = @createur_team, [date_C] = @date_C, [modif_id] = @modif_id, [modif_team] = @modif_team, [date_M] = @date_M, [date_CL] = @date_CL, [commune] = @commune, [codep] = @codep, [utmx] = @utmx, [utmy] = @utmy, [pays] = @pays WHERE [resaid] = @resaid">
                        <InsertParameters>
                            <asp:Parameter Name="resaid" Type="String" />
                            <asp:Parameter Name="localid" Type="String" />
                            <asp:Parameter Name="samuref" Type="String" />
                            <asp:Parameter Name="createur_id" Type="String" />
                            <asp:Parameter Name="createur_team" Type="String" />
                            <asp:Parameter Name="date_C" Type="DateTime" />
                            <asp:Parameter Name="modif_id" Type="String" />
                            <asp:Parameter Name="modif_team" Type="String" />
                            <asp:Parameter Name="date_M" Type="DateTime" />
                            <asp:Parameter Name="date_CL" Type="DateTime" />
                            <asp:Parameter Name="commune" Type="String" />
                            <asp:Parameter Name="codep" Type="String" />
                            <asp:Parameter Name="utmx" Type="String" />
                            <asp:Parameter Name="utmy" Type="String" />
                            <asp:Parameter Name="pays" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="localid" Type="String" />
                            <asp:Parameter Name="samuref" Type="String" />
                            <asp:Parameter Name="createur_id" Type="String" />
                            <asp:Parameter Name="createur_team" Type="String" />
                            <asp:Parameter Name="date_C" Type="DateTime" />
                            <asp:Parameter Name="modif_id" Type="String" />
                            <asp:Parameter Name="modif_team" Type="String" />
                            <asp:Parameter Name="date_M" Type="DateTime" />
                            <asp:Parameter Name="date_CL" Type="DateTime" />
                            <asp:Parameter Name="commune" Type="String" />
                            <asp:Parameter Name="codep" Type="String" />
                            <asp:Parameter Name="utmx" Type="String" />
                            <asp:Parameter Name="utmy" Type="String" />
                            <asp:Parameter Name="pays" Type="String" />
                            <asp:Parameter Name="resaid" Type="String" />
                        </UpdateParameters>
                        <DeleteParameters>
                            <asp:Parameter Name="resaid" Type="String" />
                        </DeleteParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td colspan="3" style="height: 21px">
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
